<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							
						<pageSet name="Storage Name" refQuery="Data Domain Nodes">
			<detailPages><page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><list showColumnTitles="hide" refQuery="Data Domain Nodes" name="List5">
			<listColumns>
				<listColumn>
					<listColumnTitle>
						<contents/>
					</listColumnTitle>
					<listColumnBody>
						<contents><list horizontalPagination="true" name="List4" refQuery="Data Domain Nodes">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>Table</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1300px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>EMC Data Domain Inventory</staticValue></dataSource></textItem><textItem><dataSource><staticValue> For </staticValue></dataSource></textItem><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Usable Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater1" refQuery="Report">
			<contents><textItem><dataSource><dataItemValue refDataItem="Usable (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Array"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Used Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater2" refQuery="Report">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Array"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Real Used Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater3" refQuery="Efficiency Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="Real Used Capacity (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage Name"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Storage Efficiency Savings</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><repeater name="Repeater4" refQuery="Efficiency Current">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Savings"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage Name"/></detailContext></masterDetailLink></masterDetailLinks></repeater></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:10px;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Efficiency Savings Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart7" refQuery="Efficiency Trends">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="true"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="false"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Savings"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:400px;height:200px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage Name"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Savings Ratio Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart8" refQuery="Efficiency Trends">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="true"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="false"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Ratio"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="##':1'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:400px;height:200px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage Name"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Real Used Capacity</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart9" refQuery="Efficiency Trends">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="true"/></dataFormat></style></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="false"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Real Used Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:400px;height:200px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage Name"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="3"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Data Domain Forecast Capacity</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(12 Months)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart10" refQuery="Data Domain Capacity Forecast">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="true" showMonths="shortName" showDays="false"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineAreaShape="smooth" lineDisplayType="lineAndMarkers"><v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#88B2D3"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#FFB2C1"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Projected Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Projected Used Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:1255px;height:200px;color:#454545"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Data Domain Device Inventory</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List2" refQuery="DD Inventory">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Device"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Device"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Metric"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Metric"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage"/></detailContext></masterDetailLink></masterDetailLinks></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>MTrees</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List3" refQuery="MTrees" rowsPerPage="100">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="MTree"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="MTree"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Quota Hard Limit (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Quota Hard Limit (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Quota Soft Limit (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Quota Soft Limit (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Quota Used (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Quota Used (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="MTree Status"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="MTree Status"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="MTree Oplocks"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="MTree Oplocks"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Storage Name"/></masterContext><detailContext><dataItemContext refDataItem="Storage Name"/></detailContext></masterDetailLink></masterDetailLinks></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></listColumnBody></listColumn></listColumns></list></contents>
						<style>
							<defaultStyles>
								<defaultStyle refStyle="sb"/>
							</defaultStyles>
						</style>
					</listColumnBody>
				</listColumn>
			</listColumns>
			
			
			
			<style>
				<CSS value="border-collapse:collapse; width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="sc"/>
				</defaultStyles>
			</style>
		<listGroups><listGroup refDataItem="Storage Name"><listHeader><listRows><listRow><rowCells><rowCell><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem><textItem><dataSource><staticValue>: </staticValue></dataSource></textItem><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="sh"/></defaultStyles><CSS value="display:none"/></style></rowCell></rowCells></listRow></listRows></listHeader><XMLAttributes><XMLAttribute name="RS_SectionedEdge" value="columns" output="no"/></XMLAttributes></listGroup></listGroups><sectionsFrame refFrame="List4" sectionedEdge="columns"/></list></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							<pageSetup orientation="portrait"><customPaper width="12" height="11" unit="in"/></pageSetup></page></detailPages>
		<pageGroups><pageGroup refDataItem="Storage Name"/></pageGroups></pageSet></reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>2.31 EMC Data Domain Inventory</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Report">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
UPPER(dwh_capacity.storage_dimension.name) as 'Array',
dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
dwh_capacity.storage_dimension.family as 'Family',
dwh_capacity.storage_dimension.model as 'Model',
dwh_capacity.storage_dimension.serialnumber as 'Serial #',
dwh_capacity.storage_dimension.microcodeversion as 'Microcode',
(SELECT dwh_inventory.storage.cpucount FROM dwh_inventory.storage WHERE dwh_inventory.storage.id=dwh_capacity.storage_dimension.id ) as 'CPU Count',

ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024,2) as 'Usable (TB)',
ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedcapacityMB)/1024/1024,2) as 'Used (TB)',
SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedcapacityMB)/ SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB) as '% Used',



ROUND((SELECT 
dwh_inventory.internal_volume.deduperatio

FROM dwh_inventory.storage
JOIN dwh_inventory.internal_volume
ON dwh_inventory.internal_volume.storageid=dwh_inventory.storage.id
WHERE dwh_inventory.internal_volume.dedupeEnabled=true 
AND dwh_inventory.storage.id=dwh_capacity.storage_dimension.id
GROUP BY dwh_inventory.storage.id),2) as 'Dedupe Ratio',


(SELECT 
(SUM(ROUND(dwh_inventory.internal_volume.dataUsedCapacityMB * ((1-dwh_inventory.internal_volume.dedupeRatio)/dwh_inventory.internal_volume.dedupeRatio),2)))/1024/1024

FROM dwh_inventory.storage
JOIN dwh_inventory.internal_volume
ON dwh_inventory.internal_volume.storageid=dwh_inventory.storage.id
WHERE dwh_inventory.internal_volume.dedupeEnabled=true 
AND dwh_inventory.storage.id=dwh_capacity.storage_dimension.id
GROUP BY dwh_inventory.storage.id) as 'Dedupe Savings (TB)'


FROM dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN dwh_capacity.storage_dimension
ON   dwh_capacity.storage_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagetk
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.datetk
AND  dwh_capacity.date_dimension.latest=1

WHERE dwh_capacity.storage_dimension.family LIKE CONCAT('%','Data Domain','%')

GROUP BY dwh_capacity.storage_dimension.tk


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Array"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Family"/><mdProjectedItem name="Model"/><mdProjectedItem name="Serial #"/><mdProjectedItem name="Microcode"/><mdProjectedItem name="CPU Count"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="% Used"/><mdProjectedItem name="Dedupe Ratio"/><mdProjectedItem name="Dedupe Savings (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Array"><expression>[SQL1].[Array]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL1].[Manufacturer]</expression></dataItem><dataItem name="Family"><expression>[SQL1].[Family]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Serial #"><expression>[SQL1].[Serial #]</expression></dataItem><dataItem name="Microcode"><expression>[SQL1].[Microcode]</expression></dataItem><dataItem name="CPU Count"><expression>[SQL1].[CPU Count]</expression></dataItem><dataItem name="Usable (TB)"><expression>[SQL1].[Usable (TB)]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL1].[Used (TB)]</expression></dataItem><dataItem name="% Used"><expression>[SQL1].[% Used]</expression></dataItem><dataItem name="Dedupe Ratio"><expression>[SQL1].[Dedupe Ratio]</expression></dataItem><dataItem name="Dedupe Savings (TB)"><expression>[SQL1].[Dedupe Savings (TB)]</expression></dataItem></selection>
		</query><query name="Efficiency Trends">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.storage_dimension.name as 'Storage Name',
ROUND(SUM(dwh_capacity.internal_volume_capacity_fact.dataUsedCapacityMB)/1024/1024, 2) as 'Used (TB)',

(SUM(ROUND(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB * ((1-dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio),2)))/1024/1024 as DedupeSavingsTB,

(SUM(ROUND(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB * ((1-dwh_capacity.internal_volume_capacity_fact.compressionRatio)/dwh_capacity.internal_volume_capacity_fact.compressionRatio),2)))/1024/1024 as CompressionSavingsTB,

ROUND(SUM(dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB)/1024/1024,2) as allocatedTB,


((SUM(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB) +
(SUM(ROUND(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB * ((1-dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio),2)))
+
(SUM(ROUND(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB * ((1-dwh_capacity.internal_volume_capacity_fact.compressionRatio)/dwh_capacity.internal_volume_capacity_fact.compressionRatio),2))))  / SUM(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB))  as 'Total Ratio',



dwh_capacity.date_dimension.fulldate as 'Full Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.storage_dimension
ON   dwh_capacity.storage_dimension.tk=dwh_capacity.internal_volume_capacity_fact.storagetk
AND  dwh_capacity.storage_dimension.family LIKE CONCAT('%','Data Domain','%')
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND  dwh_capacity.date_dimension.repweek=1


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN dwh_capacity.internal_volume_capacity_fact 
ON dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY



GROUP BY dwh_capacity.storage_dimension.name, dwh_capacity.date_dimension.tk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="DedupeSavingsTB"/><mdProjectedItem name="CompressionSavingsTB"/><mdProjectedItem name="allocatedTB"/><mdProjectedItem name="Total Ratio"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="DedupeSavingsTB"><expression>[SQL2].[DedupeSavingsTB]</expression></dataItem><dataItem name="CompressionSavingsTB"><expression>[SQL2].[CompressionSavingsTB]</expression></dataItem><dataItem name="Full Date"><expression>[SQL2].[Full Date]</expression></dataItem><dataItem name="Total Savings" aggregate="total"><expression>if([CompressionSavingsTB] is not null) THEN 
([CompressionSavingsTB]+[DedupeSavingsTB]) ELSE ([DedupeSavingsTB])</expression></dataItem><dataItem name="allocatedTB" aggregate="total"><expression>[SQL2].[allocatedTB]</expression></dataItem><dataItem name="Total Ratio" aggregate="total"><expression>[SQL2].[Total Ratio]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL2].[Used (TB)]</expression></dataItem><dataItem name="Real Used Capacity (TB)" aggregate="total"><expression>[DedupeSavingsTB]+[CompressionSavingsTB]+[Used (TB)]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem></selection>
		</query><query name="Efficiency Current">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT

dwh_capacity.storage_dimension.name as 'Storage Name',
ROUND(SUM(dwh_capacity.internal_volume_capacity_fact.dataUsedCapacityMB)/1024/1024, 2) as 'Used (TB)',

(SUM(ROUND(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB * ((1-dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio),2)))/1024/1024 as DedupeSavingsTB,

(SUM(ROUND(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB * ((1-dwh_capacity.internal_volume_capacity_fact.compressionRatio)/dwh_capacity.internal_volume_capacity_fact.compressionRatio),2)))/1024/1024 as CompressionSavingsTB,

ROUND(SUM(dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB)/1024/1024,2) as allocatedTB,


((SUM(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB) +
(SUM(ROUND(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB * ((1-dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio),2)))
+
(SUM(ROUND(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB * ((1-dwh_capacity.internal_volume_capacity_fact.compressionRatio)/dwh_capacity.internal_volume_capacity_fact.compressionRatio),2))))  / SUM(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB))  as 'Total Ratio',



dwh_capacity.date_dimension.fulldate as 'Full Date'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.storage_dimension
ON   dwh_capacity.storage_dimension.tk=dwh_capacity.internal_volume_capacity_fact.storagetk
AND  dwh_capacity.storage_dimension.family LIKE CONCAT('%','Data Domain','%')
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk



WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN dwh_capacity.internal_volume_capacity_fact 
ON dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY


GROUP BY dwh_capacity.storage_dimension.name


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="DedupeSavingsTB"/><mdProjectedItem name="CompressionSavingsTB"/><mdProjectedItem name="allocatedTB"/><mdProjectedItem name="Total Ratio"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Used (TB)" aggregate="total"><expression>[SQL3].[Used (TB)]</expression></dataItem><dataItem name="DedupeSavingsTB"><expression>[SQL3].[DedupeSavingsTB]</expression></dataItem><dataItem name="CompressionSavingsTB"><expression>[SQL3].[CompressionSavingsTB]</expression></dataItem><dataItem name="allocatedTB" aggregate="total"><expression>[SQL3].[allocatedTB]</expression></dataItem><dataItem name="Total Ratio"><expression>[SQL3].[Total Ratio]</expression></dataItem><dataItem name="Full Date"><expression>[SQL3].[Full Date]</expression></dataItem><dataItem name="Real Used Capacity (TB)" aggregate="total"><expression>[DedupeSavingsTB]+[CompressionSavingsTB]+[Used (TB)]</expression></dataItem><dataItem name="Total Savings" aggregate="total"><expression>if([CompressionSavingsTB] is not null) THEN 
([CompressionSavingsTB]+[DedupeSavingsTB]) ELSE ([DedupeSavingsTB])</expression></dataItem><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem></selection>
		</query><query name="DD Inventory">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.storage_dimension.name as 'Storage',
'Storage Device Name' as 'Device',
dwh_capacity.storage_dimension.name as 'Metric'
FROM dwh_capacity.storage_dimension
WHERE dwh_capacity.storage_dimension.latest=1
AND dwh_capacity.storage_dimension.family='Data Domain'


UNION

SELECT
dwh_capacity.storage_dimension.name as 'Storage',
'Storage Manufacturer' as 'Device',
dwh_capacity.storage_dimension.manufacturer as 'Metric'
FROM dwh_capacity.storage_dimension
WHERE dwh_capacity.storage_dimension.latest=1
AND dwh_capacity.storage_dimension.family='Data Domain'


UNION

SELECT
dwh_capacity.storage_dimension.name as 'Storage',
'Family' as 'Device',
dwh_capacity.storage_dimension.family as 'Metric'
FROM dwh_capacity.storage_dimension
WHERE dwh_capacity.storage_dimension.latest=1
AND dwh_capacity.storage_dimension.family='Data Domain'


UNION

SELECT
dwh_capacity.storage_dimension.name as 'Storage',
'Model' as 'Device',
dwh_capacity.storage_dimension.model as 'Metric'
FROM dwh_capacity.storage_dimension
WHERE dwh_capacity.storage_dimension.latest=1
AND dwh_capacity.storage_dimension.family='Data Domain'

UNION

SELECT
dwh_capacity.storage_dimension.name as 'Storage',
'Serial #' as 'Device',
dwh_capacity.storage_dimension.serialnumber as 'Metric'
FROM dwh_capacity.storage_dimension
WHERE dwh_capacity.storage_dimension.latest=1
AND dwh_capacity.storage_dimension.family='Data Domain'

UNION

SELECT
dwh_capacity.storage_dimension.name as 'Storage',
'Microcode' as 'Device',
dwh_capacity.storage_dimension.microcodeversion as 'Metric'
FROM dwh_capacity.storage_dimension
WHERE dwh_capacity.storage_dimension.latest=1
AND dwh_capacity.storage_dimension.family='Data Domain'

UNION

SELECT
dwh_inventory.storage.name as 'Storage',
'MTree Count' as 'Device',
COUNT(DISTINCT dwh_inventory.qtree.identifier)  as 'Metric'

FROM dwh_inventory.storage
JOIN dwh_inventory.qtree
ON   dwh_inventory.qtree.storageid=dwh_inventory.storage.id
WHERE dwh_inventory.storage.family='Data Domain'

GROUP BY dwh_inventory.storage.name

UNION

SELECT

dwh_inventory.storage.name as 'Storage',
'Volume Count' as 'Device',
COUNT(DISTINCT dwh_inventory.internal_volume.name)  as 'Metric'

FROM dwh_inventory.storage
JOIN dwh_inventory.internal_volume
ON   dwh_inventory.internal_volume.storageid=dwh_inventory.storage.id
WHERE dwh_inventory.storage.family='Data Domain'

GROUP BY dwh_inventory.storage.name


UNION

SELECT

dwh_inventory.storage.name as 'Storage',
'Usable Capacity (TB) in Storage Pools' as 'Device',
ROUND(SUM(dwh_inventory.storage_pool.totalAllocatedCapacityMB)/1024/1024,2) as 'Metric'

FROM dwh_inventory.storage
JOIN dwh_inventory.storage_pool
ON   dwh_inventory.storage_pool.storageid=dwh_inventory.storage.id
WHERE dwh_inventory.storage.family='Data Domain'

GROUP BY dwh_inventory.storage.name


UNION

SELECT

dwh_inventory.storage.name as 'Storage',
'Used Capacity (TB) in Storage Pools' as 'Device',
ROUND(SUM(dwh_inventory.storage_pool.totalUsedCapacityMB)/1024/1024,2) as 'Metric'

FROM dwh_inventory.storage
JOIN dwh_inventory.storage_pool
ON   dwh_inventory.storage_pool.storageid=dwh_inventory.storage.id
WHERE dwh_inventory.storage.family='Data Domain'

GROUP BY dwh_inventory.storage.name


UNION

SELECT

dwh_inventory.storage.name as 'Storage',
'Allocated Volume Capacity (TB)' as 'Device',
ROUND(SUM(dwh_inventory.internal_volume.totalAllocatedCapacityMB)/1024/1024,2)  as 'Metric'

FROM dwh_inventory.storage
JOIN dwh_inventory.internal_volume
ON   dwh_inventory.internal_volume.storageid=dwh_inventory.storage.id
WHERE dwh_inventory.storage.family='Data Domain'

GROUP BY dwh_inventory.storage.name

UNION

SELECT

dwh_capacity.storage_dimension.name as 'Storage',
'Dedupe Savings (TB)' as 'Device',
ROUND((SUM(ROUND(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB * ((1-dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio),2)))/1024/1024,2) as 'Metric'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.storage_dimension
ON   dwh_capacity.storage_dimension.tk=dwh_capacity.internal_volume_capacity_fact.storagetk
AND  dwh_capacity.storage_dimension.family LIKE CONCAT('%','Data Domain','%')
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN dwh_capacity.internal_volume_capacity_fact 
ON dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY


GROUP BY dwh_capacity.storage_dimension.name


UNION

SELECT

dwh_capacity.storage_dimension.name as 'Storage',
'Compression Savings (TB)' as 'Device',
ROUND((SUM(ROUND(dwh_capacity.internal_volume_capacity_fact.datausedCapacityMB * ((1-dwh_capacity.internal_volume_capacity_fact.compressionRatio)/dwh_capacity.internal_volume_capacity_fact.compressionRatio),2)))/1024/1024,2) as 'Metric'

FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.storage_dimension
ON   dwh_capacity.storage_dimension.tk=dwh_capacity.internal_volume_capacity_fact.storagetk
AND  dwh_capacity.storage_dimension.family LIKE CONCAT('%','Data Domain','%')
JOIN dwh_capacity.date_dimension
ON   dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN dwh_capacity.internal_volume_capacity_fact 
ON dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY


GROUP BY dwh_capacity.storage_dimension.name





</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage"/><mdProjectedItem name="Device"/><mdProjectedItem name="Metric"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Device"><expression>[SQL4].[Device]</expression></dataItem><dataItem name="Metric"><expression>[SQL4].[Metric]</expression></dataItem><dataItem name="Storage"><expression>[SQL4].[Storage]</expression></dataItem></selection>
		</query><query name="MTrees">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_inventory.storage.name as 'Storage Name',
dwh_inventory.qtree.identifier as 'MTree',
ROUND(dwh_inventory.qtree.quotaHardCapacityLimitMB/1024,2) as 'Quota Hard Limit (GB)',
ROUND(dwh_inventory.qtree.quotaSoftCapacityLimitMB/1024,2) as 'Quota Soft Limit (GB)',
ROUND(dwh_inventory.qtree.quotaUsedCapacityMB/1024,2) as 'Quota Used (GB)',
dwh_inventory.qtree.status as 'MTree Status',
IF(dwh_inventory.qtree.oplocks=1, 'Enabled', 'Disabled') as 'MTree Oplocks'

FROM dwh_inventory.storage
JOIN dwh_inventory.qtree
ON   dwh_inventory.qtree.storageid=dwh_inventory.storage.id
WHERE dwh_inventory.storage.family='Data Domain'

GROUP BY dwh_inventory.storage.name, dwh_inventory.qtree.identifier</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="MTree"/><mdProjectedItem name="Quota Hard Limit (GB)"/><mdProjectedItem name="Quota Soft Limit (GB)"/><mdProjectedItem name="Quota Used (GB)"/><mdProjectedItem name="MTree Status"/><mdProjectedItem name="MTree Oplocks"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL5].[Storage Name]</expression></dataItem><dataItem name="MTree"><expression>[SQL5].[MTree]</expression></dataItem><dataItem name="Quota Hard Limit (GB)"><expression>[SQL5].[Quota Hard Limit (GB)]</expression></dataItem><dataItem name="Quota Soft Limit (GB)"><expression>[SQL5].[Quota Soft Limit (GB)]</expression></dataItem><dataItem name="Quota Used (GB)"><expression>[SQL5].[Quota Used (GB)]</expression></dataItem><dataItem name="MTree Status"><expression>[SQL5].[MTree Status]</expression></dataItem><dataItem name="MTree Oplocks"><expression>[SQL5].[MTree Oplocks]</expression></dataItem></selection>
		</query><query name="Data Domain Nodes">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_inventory.storage.name as 'Storage Name'

FROM dwh_inventory.storage
WHERE dwh_inventory.storage.family='Data Domain'</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL6].[Storage Name]</expression></dataItem></selection>
		</query><query name="Data Domain Capacity Forecast">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS 'Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS 'Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS 'Used Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS 'Provisioned (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS 'Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS 'Internal Volume Allocated Capacity (TB)', 
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS 'Internal Volume Consumed Capacity (TB)',
	NULL AS 'Projected Raw Capacity (TB)',
	NULL AS 'Projected Capacity (TB)',
	NULL AS 'Projected Used Capacity (TB)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND	dwh_capacity.storage_dimension.family='Data Domain'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN 
dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate
UNION
SELECT 	
	dwh_capacity.storage_dimension.datacenter as 'Data Center',
	dwh_capacity.storage_dimension.name as 'Storage Name',
	dwh_capacity.storage_dimension.manufacturer as 'Manufacturer',
	dwh_capacity.storage_dimension.model as 'Model',
	dwh_capacity.storage_pool_dimension.name as 'Pool Name',
	dwh_capacity.tier_dimension.name as 'Tier Name',
	dwh_capacity.tier_dimension.cost as 'Cost',
	dwh_capacity.date_dimension.fullDate AS 'Full Date',
	NULL AS 'Raw Capacity (TB)',
	NULL AS 'Capacity (TB)',
	NULL AS 'Used Capacity (TB)',
	NULL AS 'Provisioned (TB)',
	NULL AS 'Volume Consumed Capacity (TB)',
	NULL AS 'Internal Volume Allocated Capacity (TB)',
	NULL AS 'Internal Volume Consumed Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.rawcapacityMB)/1024/1024, 2) AS 'Projected Raw Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.capacityMB)/1024/1024, 2) AS 'Projected Capacity (TB)',
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_future_fact.usedCapacityMB)/1024/1024, 2) AS 'Projected Used Capacity (TB)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_future_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_dimension.family='Data Domain'
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_future_fact.storagepooltk

JOIN	dwh_capacity.tier_dimension
ON	dwh_capacity.tier_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_future_fact.tiertk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_future_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.repMonthOrLatest = 1
GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.storage_pool_dimension.name, dwh_capacity.date_dimension.fullDate
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Model"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Tier Name"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Raw Capacity (TB)"/><mdProjectedItem name="Capacity (TB)"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Volume Consumed Capacity (TB)"/><mdProjectedItem name="Internal Volume Allocated Capacity (TB)"/><mdProjectedItem name="Internal Volume Consumed Capacity (TB)"/><mdProjectedItem name="Projected Raw Capacity (TB)"/><mdProjectedItem name="Projected Capacity (TB)"/><mdProjectedItem name="Projected Used Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL7].[Data Center]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL7].[Storage Name]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL7].[Manufacturer]</expression></dataItem><dataItem name="Model"><expression>[SQL7].[Model]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL7].[Pool Name]</expression></dataItem><dataItem name="Tier Name"><expression>[SQL7].[Tier Name]</expression></dataItem><dataItem name="Cost"><expression>[SQL7].[Cost]</expression></dataItem><dataItem name="Full Date"><expression>[SQL7].[Full Date]</expression></dataItem><dataItem name="Raw Capacity (TB)"><expression>[SQL7].[Raw Capacity (TB)]</expression></dataItem><dataItem name="Capacity (TB)" aggregate="total"><expression>[SQL7].[Capacity (TB)]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total"><expression>[SQL7].[Used Capacity (TB)]</expression></dataItem><dataItem name="Provisioned (TB)"><expression>[SQL7].[Provisioned (TB)]</expression></dataItem><dataItem name="Volume Consumed Capacity (TB)"><expression>[SQL7].[Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Allocated Capacity (TB)"><expression>[SQL7].[Internal Volume Allocated Capacity (TB)]</expression></dataItem><dataItem name="Internal Volume Consumed Capacity (TB)"><expression>[SQL7].[Internal Volume Consumed Capacity (TB)]</expression></dataItem><dataItem name="Projected Raw Capacity (TB)"><expression>[SQL7].[Projected Raw Capacity (TB)]</expression></dataItem><dataItem name="Projected Capacity (TB)" aggregate="total"><expression>[SQL7].[Projected Capacity (TB)]</expression></dataItem><dataItem name="Projected Used Capacity (TB)" aggregate="total"><expression>[SQL7].[Projected Used Capacity (TB)]</expression></dataItem></selection>
		</query></queries></report>